The C1CollectionView interface also includes support for filtering data through its Filter property. The Filter property specifies a method that is called for each item in the collection. If the method returns true, then the item is included in the view. If the method returns false, then the item is filtered out of view. This type of method is a predicate method.

The FlexGridSamples solution included with this Studio's samples includes a SearchBox control that consists of a TextBox control where the user types a value to search for and a timer. The timer provides a small delay to allow users to type the values to search for without re-applying the filter after each character.

When the user stops typing, the timer elapses and applies the filter using this code:

bool Filter(object item)
{
    // get search text
    var srch = _txtSearch.Text;
    // no text? show all items
    if (string.IsNullOrEmpty(srch))
    {
        return true;
    }
    // show items that contain the text in any of the specified properties
    foreach (PropertyInfo pi in _propertyInfo)
    {
        var value = pi.GetValue(item, null) as string;
        if (value != null && value.IndexOf(srch, StringComparison.OrdinalIgnoreCase) > -1)
        {
            return true;
        }
    }
    // exclude this item...
    return false;
}

 Note how the code sets the value of the Filter property using a boolean function.

This function takes an item as a parameter, gets the value of the specified properties for the object, and returns true if any of the object's properties contain the string being searched for.

For example, if the objects were of type "Song" and the properties specified were "Title", "Album", and "Artist", then the function would return true if the string being searched for were found in the song's title, album, or artist. This is a powerful and easy-to-use search mechanism similar to the one used in Apple's iTunes application.

As soon as the filter is applied, the grid (and any other controls bound to the C1CollectionView object) will reflect the result of the filter by showing only the items selected by the filter.

Note that filtering and grouping work perfectly well together. The image below shows a very large song list with a filter applied to it:

The image shown was taken when the filter was set to the word “Water”. The filter looks for matches in all fields (song, album, artist), so all “Creedence Clearwater Revival” songs are automatically included.

Notice the status label displayed above the grid. It is automatically updated whenever the list changes, so when the filter is applied the status is updated to reflect the new filter. The routine that updates the status uses LINQ to calculate the number of artists, albums, and songs selected, as well as the total storage and play time. The song status update routine is implemented as follows:

// update song status
void UpdateSongStatus()
{
    var view = _flexiTunes.ItemsSource as C1.Xaml.IC1CollectionView;
    var songs = view.OfType<Song>();
    _txtSongs.Text = string.Format("{0:n0} Artists; {1:n0} Albums; {2:n0} Songs; {3:n0} MB of storage; {4:n2} days of music.",
        (from s in songs select s.Artist).Distinct().Count(),
        (from s in songs select s.Album).Distinct().Count(),
        songs.Count(),
        (double)(from s in songs select s.Size / 1024.0 / 1024.0).Sum(),
        (double)(from s in songs select s.Duration / 1000.0 / 3600.0 / 24.0).Sum());
}

This routine is not directly related to the grid, but is listed here because it shows how you can leverage the power of LINQ to summarize status information that is often necessary when showing grids bound to large data sources.

The LINQ statement above uses the Distinct and Count commands to calculate the number of artists, albums, and songs currently exposed by the data source. It also uses the Sum command to calculate the total storage and play time for the current selection.

Copyright © GrapeCity, inc. All rights reserved.